[Table of Contents] [docx version]
Error! No text of specified style in document.
DrawingML - SpreadsheetML Drawing
Within a SpreadsheetML document, it is possible to include graphical DrawingML objects:
• Pictures (§5.2)
• Locked Canvases (§5.4)
• Diagrams (§5.9)
• Charts (§5.7)
When these objects are present in a spreadsheet document, it is necessary to include information which specifies how the objects shall be positioned relative to the parent worksheet. [Example: Whether the object is anchored to a specific row, whether it resizes with cells, and so on. end example]
The SpreadsheetML Drawing namespace acts in this capacity, specifying all information necessary to anchor and display DrawingML objects within a spreadsheet document.
[Example: Consider a DrawingML picture which shall be anchored to a specific cell for its top left and bottom right corners, resizing as those cells are relocated. This object would be specified as follows:
<xdr:twoCellAnchor>
<xdr:from>
...
</xdr:from>
<xdr:to>
...
</xdr:to>
<xdr:graphicFrame>
...
<a:graphic>
<a:graphicData
uri="http://schemas.openxmlformats.org/drawingml/2006/diagram">
<dgm:relIds xmlns:dgm="..." xmlns:r="..." r:dm="rId1" r:lo="rId2"
r:qs="rId3" r:cs="rId4" />
</a:graphicData>
</a:graphic>
</xdr:graphicFrame>
</xdr:twoCellAnchor>
The twoCellAnchor element (§5.6.2.32) specifies that this object anchored to the cells specified by the to (§5.6.2.31) and from (§5.6.2.14) elements. end example]